Question { Satyam, 16520 }

why cant we put a sequence generator or upd strategy
transformation before joiner transformation?

Answer

Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .

Question { 5610 }

what is the difference between normal & bulk loading? and
which one is recommended ? why?

Answer

normalloding:
this is the optin which we to set in the session under
mapping tab.this will represents the loading of data into
target.this is slower when compared to bulk load.this can
load the data even if u have constraints built on u r
target.this will create the session logs

bulloading
it is the faster loading method.we can' load if u have
constraint defined.this will not create sesion logs

generally normal loading is preffered

Question { 4610 }

when should one create lookup transformation ?

Answer

generally lookup is used to search for a record.in realtime
mainly people use this to fetch the key values doing a
lookup on the other table.

Question { 3539 }

what is a parameter when and where do u them when does the
value will be created. Designing time, run time. If u don't
create parameter what will happen?

Answer

oh such a big question!
parameter withn values are generally created in a notepad
in the specified location.IN the mapping go to designer--
>mappingparameters/variables->u set the parameters there .
coming to the usage in realtime what we do is we will
create the source and target connection information in the
parameter files.

one simple example to make u understand it's use is
let's take dollar and rupee relation.dollar value is not
conatant everday it will change ,so u can't change u r
mapping every day,hence what u will do is u will create the
mapping as per the requirement but u will save the dollar
value in the parameter file .so if u want to change it's
value u will change the parameter file not the mapping.

if u didn't get let me knoe i will answer again.

Question { 5863 }

what is the difference between OLTP database and data
warehousing database?

Answer

The main deference between them is

OLTP:used to store current transaction data not large
historical data(ex:bank ATM)
DWH:
used to store historical data aruond 3-6 years.

apart this include the standara differences

Question { 3977 }

what happens if the info.server doesn't find the session
parameter in the parameter file?

Answer

session will fail

Question { 3392 }

Eliminating of duplicate records without using dynamic lookups

Answer

use distinct at sql override,use agrgregator etc

Question { 14503 }

how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.

Answer

use oracle join in SQL override

Question { 3429 }

can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.

Answer

yes,there are many examples for this I will give one let's
take expresion using for ltrim and rtim operation,date
conversions etc.

Question { 4758 }

what happens if the info.server doesn't find the session
parameter in the parameter file?

Answer

session will fail

Question { TCS, 11784 }

What is A complex mapping?

Answer

A complex mapping generally will have the following
charectaristics
1.difficult requirement
2.More no.of transformation
3.having difficult business logics
4.may require combinatio of two or more methods combination

Question { HP, 12328 }

Which gives the more performance when compare to fixed
width and delimited file ? and why?

Answer

fixed width,because there are no delimiters to check so the
preformance will increase