Answer / priyaraj

You cannot include the following objects in a mapplet:
Normalizer transmation,COBOL sources,XML source qualifier
transmation,XML sources,Target definitions,Pre & Post
Session stored procedures,other mapplets

Answer / moorthy g

♦ Normalizer transformations
♦ Cobol sources
♦ XML Source Qualifier transformations
♦ XML sources
♦ Target definitions
♦ Pre- and post- session stored procedures
♦ Other mapplets

Answer / sunil

Normalizer,XML ,joiner,pre/post stored procedure

Answer / madhavi

reusable transformation is supported by the mapplets.

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

Describe expression transformation?

0 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

plz plz plz send client names and project names in informatica?

1 Answers  

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---