Answer Posted / vasu

There is a property at session level "Collect performance
data", you can select that property. It gives you
performance details for all the transformations.

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1197

---

How to handle decimal places while importing a flatfile into informatica?

1130

---

In development project what is the process to follow for an etl developer from day1

1650

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1172

---

What is a node in Informatica?

1003

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1885

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1805

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

949

---

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

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6356

---

Differentiate between Load Manager and DTM?

2093

---

State the differences between sql override and lookup override?

1113

---

How can repository reports be accessed without sql or other transformations?

1158

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1200

---

In informatics server which files are created during the session rums?

1063

---