Informatica
Q9>Lets take that we have a Flat File in the Source System and It was in the correct path then when we ran the workflow and we got the error as "File Not Found", what might be the reson?
Ans :: Not entered “source file name” properly at the session level
Q10>How to load 3 unstructured flat files into single target file?
Ans :: Indirect file option (configure at session level)
Q11>There are 4 columns in the table
target Definition ::
Store_id, Item, Qty, Price
101, battery, 3, 2.99
101, battery, 1 , 3.19
101, battery, 2, 2.59
Source Definition::
101, battery, 3, 2.99
101, battery, 1 , 3.19
101, battery, 2, 2.59
101, battery, 2,17.34
How can we do this using Aggregator?
Ans :: Source > aggregator (group by on store_id , item , qty ) > target
Tip :: aggregator will sort the data in descending order if u dnt use sorted input.
Q12> in the source qualifer if the default query is not generated... what is the reason...? how to slove it?
Ans :: (i)if source is flat file you cannot use this feature in source qualifier
(ii)In case if u are using the realational file as source and if u forget make the connection to the next transformation from source qulaifier .u cannot gerate SQL query
|
