Answer / zaaxs

Labeling is used to migrate specific jobs between ENV.

Ref the below link i found it useful

https://etltechsolutions.wordpress.com/2015/02/02/how-to-remove-label-in-informatica/

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---

What are Dimensional table?

0 Answers   Informatica,

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---

what is incremantal aggregation?

1 Answers  

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

---

what are the perameter and variable?

3 Answers   IBM,

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---