Answer Posted / vidyaveda4

if we dos't select the data driven option. at the time of running of the session it just simply ignores the options set in the update strategy transformation.

Why update strategy and union transformations are active? Explain with examples.

1219

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1124

---

What is the scenario which compels informatica server to reject files?

1051

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1159

---

Define filter transformation?

1079

---

How are indexes created after completing the load process?

1618

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1927

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1678

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1952

---

Write the unconnected lookup syntax and how to return more than one column.

1097

---

what is the -ve test case in your project.

2392

---

How to generate sequence numbers using expression transformation?

1073

---

Design a mapping to load a target table with the following values from the above source?

1327

---

What is different between the data warehouse and data mart?

1043

---

What does update strategy mean, and what are the different option of it?

1081

---