Answer / subhrangshu

We can use Scheduler option in Workflow to schedule the entire mapping.
Also, if we are using any central scheduler tool for this purpose, we can create a command file with PMCMD to run the workflow and schedule execution of that command file in a scheduler.

In a sequential batch can u run the session if previous session fails?

3 Answers  

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

What does cheating measurement mean?

0 Answers  

---

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,

---

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

What is the difference between view and materialised view?

6 Answers  

---