How can we use mapping variables in informatica?

0 Answers  

---

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

0 Answers   Informatica,

---

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

Tell me about informatica architecture.

2 Answers   TCS,

---

what transformations are used for Variable port?

2 Answers  

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

explain about unit testing? in real time?

0 Answers   L&T,

---

why u go for dimensions ?

3 Answers   TCS,

---