Answer / siddu

IQD:-- Impromptu Query definition file (Report)
Using Catalog(in Impromptu Administration) create a report,
save that report in IQD format,that one you can use as a
source(Meta Data source) in Cognos PowerPlay Transformer

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

---

What is Data Caches size?

0 Answers   Informatica,

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

what is unique constraint error ?

2 Answers   TCS,

---

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

---