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
Write the program through which the records can be updated?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain about cumulative Sum or moving sum?
How can we use batches?
Difference between Target-based loading and constraint-based loading?
Define mapping and session?
Repository user profiles
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Slowly changing dimensions, types and where will you use them
What is informatica powercenter repository?
server hot-ws270 is connect to Repository B. What does it mean?
where to store informatica rejected data?
Can we create a node as a gateway node and the same node can be assigned to a grid?
design of staging area?