What will happen when Mapping variable and Mapping parameter in Informatica is not defined or given? Where do you use mapping variable and mapping parameter?

garunchowdary

 Profile Answers by garunchowdary Questions by garunchowdary

• Feb 29th, 2008

Definitely it accepts the defualt values when parameters or variables are not present.

sarun5

 Profile Answers by sarun5 Questions by sarun5

• Feb 18th, 2008

Thanks Deepak. But does it take any null values or any default values to run the mapping.

Answer Question  Select Best Answer

Deepak Rajkumar

 Profile Answers by Deepak Rajkumar Questions by Deepak Rajkumar

• Feb 18th, 2008

Using Normalizer, in the normalizer properties we can add coloumns and for a coloumn we can specify the occurance levels, which converts rows into coloumns.

Answer Question  Select Best Answer

Sreeya

 Profile Answers by Sreeya Questions by Sreeya

• Feb 21st, 2008

For the 1st part, we can adopt the recovery options as given in the session property, using the recovery strategy.But using this in real time scenario has proved to take a toll on the performance.Anot...

Deepak Rajkumar

 Profile Answers by Deepak Rajkumar Questions by Deepak Rajkumar

• Feb 18th, 2008

Not sure about session stops without loading. We can join flat files without matching coloumns by:1: use a Seq. Gen. and generate Pks and join using Joiner.

Answer Question  Select Best Answer

jyothi

• Jul 24th, 2012

service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add

prashant

• Sep 3rd, 2011

Main difference between informatica 7.x and 8.x are:-

1. Java transformation is introduced in Informatica 8.x. while was not in 7.x

2.and Power exchange tool also introduced in informatica 8.x while was not in 7.x

Answer Question  Select Best Answer