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 use procedural logic inside infromatica?
What are the different types of olap? Give an example?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain direct and indirect flat file loading (source file type) - informatica
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the Process to creating lookup transformation in informatica
What is Data Caches size?
How can we improve session performance in aggregator transformation?
What is meant by target load plan?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Explain sessions and how many types of sessions are there?
What is a sorter transformation?
How big was your fact table
What is primary and backup node?