Question { 3024 }

How do you implement scheduling in Informatica?

Answer

We can use Scheduler option in Workflow to schedule the entire mapping.
Also, if we are using any central scheduler tool for this purpose, we can create a command file with PMCMD to run the workflow and schedule execution of that command file in a scheduler.

Question { 3511 }

How can you run a session without using server manager?

Answer

Using PMCMD command from command prompt.

Below link is helpful...

http://www.folkstalk.com/2012/10/pmcmd-command-usage-in-informatica.html

Question { 3300 }

Consider two cases:

(1) Power Center Server and Client on the same machine

(2) Power Center Sever and Client on the different machines

what is the basic difference in these two setups and which is recommended?

Answer

That's absolutely correct. Client and Server should be in different machines because of security purpose, safety issues & obviously for more access.

Question { 3278 }

When you connect to repository for the first time it asks you for user name & password of repository and database both.
But subsequent times it asks only repository password. Why?

Answer

When we are logging into Informatica repository for the First Time, the Metadata is getting imported into the Repository. This is why from the second time, we don't need to provide username & database or domain name. Only for authentication purpose, we have to provide the password.

Question { 4072 }

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

Answer

Sequence generator may create issue in case of partitioning. The duplicate keys get generated in sequence generator. We cannot have cannot have multiple table feeder processes.
Then, we can use either Oracle database sequences or Lookup / Expression transformation to create sequence numbers. Although, Oracle sequences are better as it
will also handle the case where there are other sources feeding the Target under consideration other than ETL. Yes, there is slight hit in performance, but it's minor in most situations.

Question { 5246 }

What is the difference between a shortcut of an object and copy of an object? Compare them.

Answer

Nikhil....you have said it completely wrong. If we change in Shortcut, it will reflect in the source. Whereas in case of copying, the source will not change if we change something in the copied object.

Copy can be done between 2 Normal folders objects or between a Shared and a Normal folder.
Shortcut's can be done from a Shared folder to Normal folder only.

Question { 3022 }

How do you implement configuration management in Informatica?

Answer

We can do the necessary configuration settings by logging into the domain from browser with admin access. Sometimes, we need to restart the Integration Service after change which can be done from here with admin access.

Question { 4235 }

What are Business Components in Informatica?

Answer

Siebel, SAP these are the business components of informatica. They are used in business and through ETL process we can loaor extract data from them.

Question { 3709 }

Two different admin users created for repository are ______ and_______

Answer

Administrator and admin

Question { Tech Mahindra, 5291 }

generate Unique sequence numbers for each partition in session with Unconnected Lookup ?




Hi All,

Please help me to resolve the below issue while Applying partitioning concept to my Session.

This is a very simple mapping with Source, Lookup , router, and target.

I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update.

while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table.

The above flow is working fine from last one year.

Now I wish to apply the Partitioning concept to the above floe(session)

At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source)

at Target I used 4 passthrough Partitions.

it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice.


In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row.

2nd row is coming from 1st partition and generated the sequence number 2 for that row

3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row)

the issue is becuase of generating the same sequence numbers twice for different partitions.

Can any one Please help me to resolve this issue.

While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data.


Regrads,
N Kiran.

Answer

Hi,
Take one parameter (i.e. $$seq) and assign initial value for the unique key (i.e. 1000). Now, from Source Qualifier take all the ports to one expression transformation. Add two additional ports in the Expression Transformation as below.

v_seq (variable port) = IIF(v_seq>0,v_seq+1,$$seq)
SEQ_NO (output port) = v_seq

In this way, the Sequence transformation can be avoided but we will have the same facility in partition scenario as we are changing the port values only.

Though I believe it will work but please let me know if it is not.