Answer / sbvp

1.FLAG
2.versioning
3.date range
there is three types to implement scd2.

Answer / pune.rohitsharma

my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2

Answer / kumar raja kotakonda

1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING

Answer / radhakrishnansk

write pl sql scripts

what are the row and column separations in Flat Files

3 Answers   CTS,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

What do you understand by term role-playing dimension?

0 Answers  

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

---