Answer Posted / vinay

Here are the steps that you will need to follow to catch record numbers 1,5,11,15,21,25,31,35.....so on.

Step1: Create an expression T/F and define a variable to count the number of records, say we name it as "CNT"
CNT (int) = CNT+1

Step2: In the same T/F, at the end of all the ports define a flag, say we name it as
flg_VALID_ROW (string(1))=
IIF((SUBSTR(TO_CHAR(CNT),-1)= '1' or
(SUBSTR(TO_CHAR(CNT),-1)= '5'),'Y','N')

Step3: Next define a Filter T/F, where you can catch hold of the record using flag = 'Y'
Filter Cond'n: flg_VALID_ROW = 'Y'

How can you differentiate between powercenter and power map?

1141

---

What is the function of union transformation?

1205

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1848

---

waht type of interface is used for testing the data in informatica

2301

---

What are Dimensional table?

1121

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2116

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2797

---

What is the scenario which compels informatica server to reject files?

1123

---

How do you handle two sessions in Informatica

1220

---

Explain pmcmd command usage in informatica

1190

---

Slowly changing dimensions, types and where will you use them

1773

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1843

---

What is meant by LDAP users?

1291

---

How do you migrate data from one environment to another?

1149

---

can anyone suggest best free Talend data integration training online

1745

---