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

Mention a few design and development best practices for informatica?

0 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

What is aggregate awareness?

1 Answers  

---

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

---

What are session parameters ? How do you set them?

0 Answers  

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---