Answer / srinivas.medagum

When i used SQ..>EXPRESSION T/R...>ROUTER...>UNION...>TRG

I AM GETTING OUTPUT ,BUT NOT IN PROPER LIKE
MALE,FEMALE
VASU
RAM
KESAV
SEETHA
SUMA


CAN I USE TWO TARGETS , HOW CAN GET IN PROPER WAY?

Answer / viney

it can be done using Normalizer transformation

Answer / sakthi

1.sq1 (query override gender='m') -> exp1 ,seq1 gen nextval to exp1

2.sq2 (query override gender='f') -> exp2 ,seq2 gen nextval to exp2

3. connnect o/p exp1 to exp2 to joiner
* condition nextvalue =nextvalue
* condition type full outer join

4. connect name from exp1 & name from exp2 to target

Answer / shiva bansal

use router and expr1 for male and expr2 for female
combine them in expression transformation and connect the
expression to target

Answer / suri

Write the condition based on the gender . so that all males
comes one side and females come another side

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

how to use incremental load?

2 Answers   TCS,

What is DTM process?

4 Answers  

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

where to select code page option?

2 Answers   TCS,

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

how do u move the code from development to production?

3 Answers  

How we can confirm all mappings in the repository simultaneously?

1 Answers  

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,