Answer / ajay pareek

first of all bad files and reject file both are same, there is no difference between them.
we call them reject fils that havving .bad extension.
there are not any files with .reject extension.
so the bad files or reject file keep the rejected records.

correct me if i am wrong

Answer / abhinaw prakash

Bad File stores data which does not pass through business
standard.
Reject file has data which does not pass through business logic.
EX:
EmpID Ename Sal
10 Abhi 10000
20 Ram 3000
30 Cp 7000
40 Rohit

Now if we apply Filter condition as Sal>5000,Then

Bad file will have records
40 Rohit
(Emp cannot have NO SALARY column)

Reject File will have record
20 Ram 3000

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---

Implementation methodology

0 Answers  

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

What is a data modeling?

2 Answers  

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---