Answer Posted / rudresh

Transformation is a repositorty object,which loads the data
into target as per the busines rule.

Transformations are two types
1)Active
2)Passive

r u done any partitions in ur project?

1407

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1469

---

Explain the tuning lookup transformation - informatica

615

---

What is the sql query overwrite in source qualifier in informatica

619

---

How to start a workflow using pmcmd command?

715

---

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1660

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1631

---

How many numbers of sessions can one group in batches?

625

---

Is there any way to read the ms excel datas directly into informatica?

552

---

What are the restrictions of union transformation?

581

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1090

---

Different sorts of metadata that stores in the storage facility?

564

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7681

---

What are the different types of repositories created using informatica?

663

---

What is the meaning of up gradation of repository?

1393

---