Answer / pr

The default join is inner join. But we can override it by using the SQL overide query and can perform any joins

How do you do error handling in Informatica?

1 Answers  

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

Explain how many types of dimensions are available in informatica?

0 Answers  

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

Why we use stored procedure transformation?

4 Answers  

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

Explain lookup transformation in informatica

0 Answers   Informatica,

---

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

---

what is incremental data aggregation?

3 Answers   IBM,

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---