Answer / sidhu

in session properties,
select mapping tab then
select target properties
there header and footer command option
there u give
echo header in header option
and echo footer in footer option

Answer / mukesh kumar

go to session edit>>>>mapping tab>>>>>>>selct
source>>>>>>in header command option and footer command
option type the command

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

What is polling in informatica ?

1 Answers   TCS,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

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

0 Answers  

---

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

---