i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
Answer Posted / srikanth
Source Qualifier transformation applies to only for
databases and not for flat files (upto versoin 7.x) but i
have no idea on later versions.
It just acts like a label and we cant configuare or use any
of the properties in source qualifier if the source is flat
file.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain lookup transformation in informatica
difference between repository database and repository service?
What is a passive transformation?
What is the difference between Active and Passive transformation?
What is incremental aggregation?
How we can create indexes after completing the loan process?
What are the tasks that source qualifier perform?
How are indexes created after completing the load process?
According to his methodology what all you need before you build a datawarehouse
Do you find any difficulty while working with flat files as source and target?
What are multi-group transformations?
What is a dimensional model?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Can we get 1st record through Informatica(without sequence number).
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?