Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answers were Sorted based on User's Feedback



can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compare..

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

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compare..

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

Post New Answer

More Informatica Interview Questions

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

4 Answers   HCL,


Write the prerequisite tasks to achieve the session partition?

0 Answers  


suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,


Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  


two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,


how much memory (size) occupied by a session at runtime

4 Answers   Wipro,


when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,


What is exclusive and normal mode for repository services?

0 Answers  


how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,


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.

0 Answers  


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

1 Answers  


What are the designer tools for creating transformations?

0 Answers   Informatica,


Categories