Answer / kiran ghatage

You will find this in following examples...
https://community.informatica.com/solutions/mapping_implementing_scd1_using_md5
https://community.informatica.com/solutions/mapping_scd_type_2_effective_date
https://community.informatica.com/solutions/mapping_scd_type_2_versioning

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

What is galaxy shema

2 Answers   CGI,

---

what is filelist concept in informatica

4 Answers  

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

---

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

3 Answers   HP,

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

Explain reference cursor?

1 Answers  

---