Answer / maruthi

1.)use to_integer('column name','newcolumn)
it works

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

how can u load the data in time dimension?

3 Answers  

---

What is a snowflake schema?

0 Answers  

---

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---

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  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

---

what is upstream and downstream transformation?

7 Answers  

---

why we use materialized view over view?

1 Answers   Zensar,

---