How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

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 is the function of aggregator transformation?

0 Answers  

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

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 .

0 Answers   Amazon,

---

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

How to open an older version of an object in the workspace?

0 Answers  

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

in performance wise union is past,union all is past

2 Answers  

---

what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,

---