Answer / pati

Day = to_char(sysdate,'Day')
Date = to_char(sysdate,'DD')
Month = to_char(sysdate,'Month')
Year = to_char(sysdate,'YYYY')
Quater = to_char(sysdate,'Q')

Explain lookup transformation in informatica

0 Answers   Informatica,

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

What are the new features in Informatica 5.0?

1 Answers  

---

What do you understand by a term domain?

0 Answers  

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

What is a poling?

2 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---