Answer Posted / zer0

Create the mapping as below:

EXP1 ---> SRT1
/ \
Src --> Router Joiner ---> EXP3 ---> Targ
\ /
EXP2 ---> SRT2

Router: Filter on the basis of gender. All records with
gender male wil go into EXP1 and the records with gender
female will go into EXP2.
In EXP1 and EXP2, create a variable dummy port (Seq_Var)
with value Seq_Var+1 and an output port Seq_Out (value-
Seq_Var).
Pass the name and sequence ports from EXP1 and EXP2 to SRT1
and SRT2 (sorter) respectively.
In SRT1 and SRT2, sort on the basis of sequence.
In Joiner, use 'Full Outer Join' and keep 'Sorted Input'
checked in properties.
Pass the male name values and female name values from
joiner to EXP3 (Gather all the data). Pass all the data to
Target.

How do we call shell scripts from informatica?

1132

---

Explain the etl program with few examples.

1060

---

What is standalone command task?

1321

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1045

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2080

---

Briefly describe lookup transformation?

1051

---

Explain the features of connected and unconnected lookup.

938

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5690

---

Explain the different dimensions.

975

---

Explain the aggregator transformation?

1174

---

State the limitations where we cannot use joiner in the mapping pipeline?

1075

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9154

---

What are the types of presistent cache in look up tr.

2059

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2017

---

Please let me know how to make Data masking in informatica..

1738

---