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?
- 2 Answers
- 5906 Views
- IBM, I also Faced
- E-Mail Answers
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 |
what are challenges that you faced in testing? give solution to it?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
Under which circumstances, informatica server creates reject files?
what is data driven?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
What could be the possible resons of locks by user?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What are the advantages of using informatica as an etl tool over teradata?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain dynamic target flat file name generation in informatica
Can yoU use the maping parameters or variables created in one maping into another maping?
What is Performance tuning in Informatica?
Teradata 
