Answer / raj

we use file type direct when we are loading single file into
target. we use Indirect when we want to load multiple files
through single session.

Answer / prashant

When we are using the Direct option at the session
level,then we are loading only single file.
But when we are using Indirect option, then we can load
multiple files also.For this we have give a list file
(.list) path in the session which will contain the names of
the files need to be loaded.

Answer / pradeep

we use file type direct when we are loading single file into
target. we use Indirect when we want to load multiple files
through single session in the mapping

Answer / srikanth chowdary

when you are using the direct method option in session side that time your loading only single file into target and when you are using indirect method that time you can create LIST.txt file then you can pass multiple files into target in a single session but need to same structure in files

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

What are the types of caches in lookup? Explain them.

0 Answers  

---

how did u understand business requirement?

2 Answers   TCS,

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

Explain your project of banking domian.

0 Answers   Cap Gemini,

---

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,

---

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,

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

How to use pmcmd utility command?

0 Answers  

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---