can we use lookup t/r in flat files?what are the t/r's can be
used in flat files when compared to relational DB?
Answer Posted / mike
1)Yes..you can use a lookup transformation on flatfiles.
2)I think we can use most of the transformations on
flatfiles.
But we can not apply slowly changing dimensions on flat
files.
correct me if i was wrong
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is complex mapping?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Separate from an archive server and a powerhouse?
How to use procedural logic inside infromatica?
What is a grid in Informatica?
Enterprise data warehouse your projects phase by phase explain?
What is different between the data warehouse and data mart?
How to use pmcmd utility command?
Define sessions in informatica etl?
What is a repository? And how to add it in an informatica client?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain sessions and how many types of sessions are there?
can anyone suggest best free Talend data integration training online
What is persistent lookup cache?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???