Answer Posted / karthiga

If mapping parameter and variable is used in the mapping
but nowhere defined or given, then session will fail.

we can define the Mapping parameter and variable using:
mappings>parameters and variables>declare parameters and
variables.
we will specify the value directly in default value or else
specify it in the parameter file.

Usually, we will specify in parameter file.

Tell me about MD5 functions in informatica

711

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

845

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

893

---

How to configure mapping in informatica?

925

---

How to load the data from a flat file into the target where the source flat file name changes daily?

823

---

What is mapplet in informatica?

795

---

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 .

1708

---

Enlist the advantages of informatica.

854

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1031

---

As union transformation gives UNION ALL output, how you will get the UNION output?

883

---

Explain what is informatica metadata and where is it stored?

833

---

How an expression transformation differs from aggregator transformation?

841

---

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?

1038

---

What are active transformations.

1420

---

What is meant by query override?

843

---