From where you extract the data, how you did it into
informatica? explain....
Answer / davankumar
Its imp ??? every company should ask these ???.If source is
relation tables source data is relational (ie means oracle
9i/10g)
But source is flat that can in unix server(client can give
path details ).in informatica we have to create the
sturuture of table and give that path address in the
session property tab.
Is This Answer Correct ? | 4 Yes | 0 No |
If we are using an aggregator but forget to mention the group by port .what will be the output??
Briefly define a session task?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
What are the restrictions of union transformation?
How can we use batches?
What is the Process to creating lookup transformation in informatica
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
why we use stored procedure transformation?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?