chandra


{ City } bangalore
< Country > india
* Profession *
User No # 10175
Total Questions Posted # 2
Total Answers Posted # 6

Total Answers Posted for My Questions # 7
Total Views for My Questions # 23558

Users Marked my Answers as Correct # 81
Users Marked my Answers as Wrong # 41
Questions / { chandra }
Questions Answers Category Views Company eMail

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

CTS, Symphony,

6 Informatica 15365

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

CTS,

1 Informatica 8193




Answers / { chandra }

Question { Systematix, 25829 }

is there more the two primary key in a single table?


Answer

no, we cant create more than one primary key in the single
bcoz it avoids the codds rule

Is This Answer Correct ?    3 Yes 1 No

Question { DELL, 127395 }

Differences between UNIQUE and DISTINCT in select statements


Answer

the diff between unique and distinct is
unique is applied before insertion and retrival.it consists
of non duplicate values.if unique constraint is given it
does not take duplicate values.distinct is used in retrival
it gives the suppressed row(ex if two rows are same it will
show single row and non duplicate row) therefore distinct is
the combination of suppressed duplicate and non duplicate rows.

Is This Answer Correct ?    35 Yes 11 No


Question { 8416 }

what are the differences between powercenter 8.1 and
powercenter 8.5?


Answer

the diff btw 8.1 and 8.5 is we can find push down operation
in mapping wch gives more flexible performance tunning.

Is This Answer Correct ?    9 Yes 3 No

Question { 22253 }

how to work with mapplet designer in informatica?


Answer

mapplet is is a set of transformations wch can be
reused.mapple can be slected in mapplet.

Is This Answer Correct ?    29 Yes 8 No

Question { 8802 }

how to load duplicate row in a target


Answer

in the source u overide the source qualifier and trough
filter u can overwriter it

Is This Answer Correct ?    0 Yes 1 No

Question { 20366 }

Is there any function in ab Initio which act like SCAN
component


Answer

yes we can use the aggregate component like a scan component

Is This Answer Correct ?    5 Yes 17 No