sanjay


{ City } delhi
< Country > india
* Profession * software engneer
User No # 31916
Total Questions Posted # 0
Total Answers Posted # 16

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 34
Users Marked my Answers as Wrong # 53
Questions / { sanjay }
Questions Answers Category Views Company eMail




Answers / { sanjay }

Question { PCS, 10851 }

What is a surrogate key?Why we use it in a mapping?Pl give
an example.


Answer

Saradhi has given the perfect example of Surrogate key..

Thnx Saradhi

Is This Answer Correct ?    2 Yes 1 No

Question { 5021 }

how to identify new and old values in source qualifier or
any other transformations using informatica


Answer

By using the scd2..we can keep the track of the old and new
records.
There are 3 ways:
1.Version Num
2.Date
3.Flag

Is This Answer Correct ?    1 Yes 0 No


Question { TCS, 9720 }

If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values


Answer

Sam is 100% correct...

Is This Answer Correct ?    1 Yes 0 No

Question { IBM, 12307 }

i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.


Answer

1. Method

We can do it through
sq->Exp Trns->filter-->Target
!
SG

In filter trans by giving a condition "NUM=1
or NUM=5" we can get the result.

* But if you run the wf next time u need to change the NUM
value bcoz sq increments the value accrdng to the defined
condition whenever it runs the session.

2. Method
We can do it through Router trns

SQ—-Exp—Router--Target1 & Target2
!
SG
In Ist group NUM=1 & in 2nd group NUM=5.

where we'll define two groups, One for row 1 and other for
row 5.
* we need to chng the SG value every time
3. method

We can do it through parameters & variables

Is This Answer Correct ?    1 Yes 0 No

Question { 19617 }

how to retrieve last tree records from table?
select *from emp where rownum > (select count(*)-3 from
emp);
i am using this query to get last three records from table
but its not giving any output, so please tell me what is the
error in this query.


Answer

SELECT ROWNUM AS rank, employee_id
FROM (SELECT employee_id
FROM employees
ORDER BY employee_id DESC)
WHERE ROWNUM<=3

Is This Answer Correct ?    0 Yes 1 No

Question { 3083 }

I am using Informatica 7.1.1. and i used emails task for
getting emails but not able to get emails is there any
settings in Informatica installation level?


Answer

If u want to use the email task, outlook should be
configured in ur system.. and u need to do some setting in
ur power center server..

u can refer help file.

Is This Answer Correct ?    0 Yes 1 No

Question { HCL, 11036 }

One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?


Answer

Sq-->Expression-->Router-->Target
| |
| v
v grp1--> col=1
mod(col,3) grp2--> col=2
Default

Is This Answer Correct ?    3 Yes 0 No

Question { HCL, 9990 }

if soource is having 10 records how will u insert 20
records to target


Answer

keep the "Truncate Target Table Option" uncheck in the
session and run the workflow two times..
You can get the 20 records..

Is This Answer Correct ?    4 Yes 7 No

Question { Accenture, 21999 }

how to join the 2 different table with different columns in
informatica?


Answer

1.By using UNION transformation we can join 2 different
table with different columns in informatica....

2.By using Sequence generator on both tables, we can join 2
different table with different columns in informatica....

Is This Answer Correct ?    1 Yes 10 No

Question { Wipro, 9708 }

how eliminate the duplicates in flat file with out using
sorter ,aggregater


Answer

here i m taking the example of employee table

first use the sorter to get the distinct value....

then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.

create filter trns.. write a condition where output>1... map
it with the target...

Is This Answer Correct ?    0 Yes 8 No

Question { Keane India Ltd, 17923 }

What r the type of indexes u generally used in informatica?


Answer

Normally we use two types of indexes in informatica.
Btree Index
Bitmap Index

Bitmap Index gives better performance than Btree Index.

Is This Answer Correct ?    10 Yes 1 No

Question { Cap Gemini, 11857 }

In EMP table, for those emp whose Hiredate is same, update
their sal by "sal+500" or else for others keep the sal as it
is, how to do it by SQL query


Answer

Hi Srinu,

you check the query once again..Query is not wrong..

UPDATE emp
SET sal=sal+500
WHERE hiredate IN (SELECT hiredate
FROM emp
HAVING COUNT(*)>1
GROUP BY hiredate

it'll give the same result whether we write count(*) or
count(hiredate)..
But I agree but its better to give count(hiredate)instead of
COUNT(*)...coz it is easier to understand.

Is This Answer Correct ?    2 Yes 1 No

Question { IBM, 10622 }

suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?


Answer

By using the Router transformation we can load half of the
record in target 1 and half in target2.

src-->source qual--->Seq Generator(If
needed)--->router--->targets

Is This Answer Correct ?    1 Yes 3 No

Question { 7488 }

While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?


Answer

You are write Krish.. we can not use update stratety in flat
files...

Can I have ur mail id plz?.. my email id is
sanjaygupta1981@gmail.com

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 22079 }

Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve


Answer

If you want to load these records on different files at
different time, you can use Filter transformation else u can
use Router transformation..
In Router trans create two ports and one default port.. and
write conditions according to your requirement....

Is This Answer Correct ?    0 Yes 6 No

 [1]   2    Next