Answer / Suhail Ahmad

Granularity refers to the level of detail in a dataset. In data modeling, particularly for fact tables, you can choose between high-level (aggregated) or low-level (detailed) granularity depending on your requirements. Having two tables with the same granularity is possible and common, but it's essential to ensure there are no redundancies or conflicts in data definition.

What are mapplets? How is it different from a Reusable Transformation?

1 Answers   Informatica,

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1 Answers  

---

What is Code Page Compatibility?

1 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

How can we remove the duplicates from flat file source?

1 Answers  

---

version controlling in informatica?

3 Answers  

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1 Answers  

---

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

---

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

---

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,

---