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
How to create Target definition for flat files?
What is session task and command task?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Design time, run time. If you don't create parameter what will happen
What is the different lookup cache(s)?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the different lookup cache(s)?
What is olap (on-line analytical processing?
What is the difference between source qualifier transformations source filter to filter transformation?
How to use procedural logic inside infromatica?
What is an expression transformation?
What is a repository? And how to add it in an informatica client?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is option by which we can run all the sessions in a batch simultaneously?
Explain the use of aggregator cache file?