Answer Posted / nitin

Create two mapping pipelines
One pipeline is to
1) Break the record 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B using normalizer transformation
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B
Then pass the records into a flat file target.

Source-->SQ-->Normaliser--> Target (Output_file1)
Output_file1-->SQ--> Aggregator-->Target(Output_file2)


Create another mapping pipeline where the above records act as the source and the delimiter as '|'.
Use an aggregator transformation to group based on the first column and use the SUM(col2) GROUP BY col1.
write the output to the target file with | as delimiter

tell me about your project functionality

2383

---

What are the different types of repositories created using informatica?

1170

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2292

---

What are the types of caches in lookup?

1096

---

whats the logic to load the lower level of granularity of data to fact table.

2311

---

How big was your fact table

1864

---

How many transformations can be used in mapplets.

1983

---

Different sorts of metadata that stores in the storage facility?

1069

---

How can we use batches?

1066

---

What all join we can perform in LOOKUP transformation?

1021

---

Why update strategy and union transformations are active? Explain with examples.

1284

---

Can you generate sequence numbers without using the sequence generator transformation?

1162

---

How we can create indexes after completing the load process?

1201

---

What is a shortcut and copy in Informatica and how two are different with each other?

1241

---

What are the different types of olap? Give an example?

1097

---