Answer / nagaraj.g

using sorter transformation for distinct in a flat files

Answer / veera reddy

By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.

Answer / seshagiri

veere reddy,

Dynamic lookup will not work for flat file only static
lookup will work for a flat file

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

How would you copy the content of one repository to another repository?

0 Answers  

---

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

---

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

---

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---

what transformations are used for Variable port?

2 Answers  

---

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

---