When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

TCS,

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

TCS,

What is sql query override? When did u use sql query override?

TCS,

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

Flextronics,

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

TCS,

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

iNautix,

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

iNautix,

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

iNautix,

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

TCS,