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
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to start a workflow using pmcmd command?
can anyone suggest best free Talend data integration training online
What is target designer and target load order?
What is the need for an etl tool?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to do the error handling of if ur source is flatfiles?
How big was your fact table
What is informatica metadata and where is it stored?
Clarify the aggregator change?
Where is metadata stored?
can u give example for factless fact table
explain about unit testing? in real time?
What is transformation?