Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6833 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 |
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
Write the prerequisite tasks to achieve the session partition?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
how much memory (size) occupied by a session at runtime
when will we go for unconnected lookup transformation in Informatica?
What is exclusive and normal mode for repository services?
how can we perform incremental aggregation?explain with example?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
What are the designer tools for creating transformations?
Teradata 
