Answer Posted / 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.

What is blocking transformation?

1144

---

How many types of sessions are there in informatica.please explain them?

1169

---

 Informatica Checkpoints

3331

---

How to join three sources using joiner?

1115

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8120

---

Which transformation is needed while using the Cobol sources as source definitions?

1174

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2194

---

What is dimensional table? Explain the different dimensions.

1172

---

What is rank transformation in informatica

1179

---

How you can differentiate between connected lookup and unconnected lookup?

1062

---

Which version configuration tool used in ur project?

3260

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2339

---

In which transformation you cannot drag ports into it?

1320

---

What is lookup transformation?

1042

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4109

---