Do you have to change the reject file b4 using reject loader utility.
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
What is a joiner transformation?
what is session override?
Explain load alternative records / rows into multiple targets - informatica
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
How many number of sessions can one group in batches?
How will you display "Mr" for male & "Mrs" for female in target table?
What is the difference Between Mapping parameter and variable