Answer Posted / chandrababu.sarupuru

Normal loading will load data row by row and it will create
the datalog for each and every record.

Bulk load will load data in bulk size at a time.It is very
faster than Normal loading .

But in case of session recovery we need data log to recover
the session.

Explain direct and indirect flat file loading (source file type) - informatica

1262

---

What is workflow? What are the components of the workflow manager?

1065

---

How can you generate reports in informatica?

972

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1727

---

what is diff b/t sorter t/r and agg have the option sorter property...

2129

---

What do mean by local and global repository?

1151

---

How can you differentiate between powercenter and power map?

1018

---

What is pmcmd command?

1045

---

Describe data concatenation?

1005

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2076

---

What could be the possible resons of locks by user?

1033

---

where to store informatica rejected data?

1046

---

How can we delete duplicate rows from flat files?

1162

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1986

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

970

---