Answer / Pal Singh

In Informatica, you can call shell scripts using the External Program task. This task allows you to execute operating system commands or any other executable files such as shell scripts. Here's how to use it:
1. Drag and drop an External Program task into your workflow.
2. Configure the command in the External Program editor. The syntax is usually: /path/to/your/script.sh (Replace /path/to/your/script.sh with the actual path to your script).
3. Set the Input and Output ports as per your requirements.

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

Differentiate between joiner and lookup transformation?

1 Answers  

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

Sequence generator, when you move from develoment to production how will you reset

1 Answers  

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

1 Answers   HGS, TCS,

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

what is degenerated dimension?

2 Answers   IBM,

---

Differentiate between reusable transformation and mapplet.

1 Answers  

---

What is source qualifier transformation?

1 Answers  

---