Answer Posted / hari

Little change in the Administrator Console.in 8.1.1 we can
do all the creation of IS and repository Service, web
service ,Domain ,node , grid( if we have licensed
version),In 8.6.1 the Informatica Admin console we can
manage both Domain page and security page.
Domain Page means all the above like creation of IS and
repository Service, web service ,Domain ,node , grid( if we
have licensed version) etc. Security page means creation of
users, privilleges,LDAP configuration , Export Import user
and Priviilleges etc .

Please let me know, if you want more details.
Thanks,
Hari

How to update source definition?

619

---

What is domain and gateway node?

683

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

614

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

660

---

What are roles and groups and benefits of using them?

561

---

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1524

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

621

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

610

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1605

---

Explain the pipeline partition with real time example?

642

---

How many ways are there to create ports?

712

---

Explain the different kinds of facts.

554

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

542

---

Define pmcmd command?

612

---

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

3754

---