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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajan raorane
No we can apply slowly changin dimensions on flat files
as they are basically used to mantian history
frequently used is SDC2 (Verison/flag/Date)
Is This Answer Correct ? | 0 Yes | 2 No |
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
How to elaborate powercenter integration service?
What is the Rankindex in Ranktransformation?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What is the use of transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What are the types of data warehouses?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?