Answer / gazulas

pmcmd startworkflow -wait -sv $INF_SERVICE -d $INF_DOMAIN -uv INF_USER -pv INF_PSWD -f $2 $1 > $PMCMD_LOGS_DIR/${1}_$DATESTAMP.log

Answer / ravi

pmcmd startworkflow -u ${infa_etl_user} -p ${infa_etl_passwd} -sv ${infa_etl_is} -d ${infa_etl_dom} -f ${folder_name} -paramfile ${parfile} -wait $workflowname

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

What are the uses of etl tools?

0 Answers  

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

Explain the types of transformations?

0 Answers  

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---