Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Dec 6th, 2007

We have Session,Command and Email tasksCheers,Thana

Siddhant Mirji

• Jul 11th, 2007

SessionCommandDecisionEvent WaitEvent raiseEmailTimerAssignmentControlWorklet

Answer Question  Select Best Answer

What is the practical use of a union transformation?

ask_kaushik

 Profile Answers by ask_kaushik Questions by ask_kaushik

• Dec 6th, 2007

That was the description....practical use would be like : if you have 3 different sources which returns different number of records but with the same ports and datatypes, union transformation can be used to sum up these records and proceed to the next transformation as the same pipeline.

ask_kaushik

 Profile Answers by ask_kaushik Questions by ask_kaushik

• Dec 6th, 2007

The Union transformation is a multiple input group transformation that you use to merge data from multiple pipelines or pipeline branches into one pipeline branch. It merges data from multiple sources...

Answer Question  Select Best Answer

prabhat007

 Profile Answers by prabhat007 Questions by prabhat007

• Dec 8th, 2007

Tracing level in the case of informatica specifies the level of detail of information that can be recorded in the session log file while executing the workflow.4 types of tracing levels supported1.Nor...

Abhishek Shukla

• Nov 19th, 2007

Tracing level keeps the information aboaut your mapping and transformation.there are 4 kind of tracing level which is responsible for giving more information on basis of their characterictis.ThanksAbhishek Shukla

Answer Question  Select Best Answer

[09/23/2007 11:34:53] (Alert) Repository gowtham has been shutdown. I am getting error like this in services informatica repository server is starting but informatica is not starting pls help in this thanks and regards gowtham

prasad1507

 Profile Answers by prasad1507 Questions by prasad1507

• Dec 11th, 2007

Please check whether u have correct user privilege in windows to start services. You should have service start privilege in windows. One more thing Informatica server will be started and alive only any workflow is created.If this doesnt help, come back with exact details of your problem

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 26th, 2007

i think u need to restart tje services again. before that check all the configurations. like repserver,server,repository admin management console.

Answer Question  Select Best Answer

Need to update the existing records,The record which is coming for update should be inserted and also the previous record's one column must be modified. i have used look up to look up the data.used router to separate the data for insertion and update.Used expression to calculate something on those new records for update.service_code valid_startdate valid_enddate01 2003-03-03...

anu_v_iitd

 Profile Answers by anu_v_iitd Questions by anu_v_iitd

• Dec 13th, 2007

Actually what need to be done here is:You need to use two update strategy transformation just before inserting or updating the data into target table, Obviously there will be two instances of target t...

Answer Question  Select Best Answer

senthilkar

 Profile Answers by senthilkar Questions by senthilkar

• Dec 17th, 2007

If the sources are homogenous, we use source qualifierif the sources have same structure we can use union transformation

chandrarekha

• Sep 24th, 2007

You can join two tables with in the same database by using lookup query override

Answer Question  Select Best Answer

Hi,Can Informatica power center 7.1.1 installed on Windows vista home premium? If so how to install informatica server and repository server?Thank you,Vamshi.

anithashriya

 Profile Answers by anithashriya Questions by anithashriya

• Dec 22nd, 2007

But i could not find an option windows xp service pack 2 after right clicking on setup.exe of informatica powercenter 7.1.1, still the error is continuing if i try to execute setup.exe ...can anyone come up with the solution

Pallavi50953

 Profile Answers by Pallavi50953 Questions by Pallavi50953

• Dec 21st, 2007

Hi,   I installed informatica powercenter 7.1 in my laptop and i can even open repository server console.   But now for connecting to the repository it is asking for a password.Can any one specify which port and password should i specify for connecting to the repository.

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

ODBC is the database drivers  which is used to connect from clinet  to the relational database.DSN is the data service name which is thename of the odbc name give by the customer inoreder to...

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

First we should generate theWarehouse key using sequence generator and insert the rows into the target using update strategy

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

By using the typeII mapping i.e. we use a seperate flag key which keeps changing when we changet the date in the table

Answer Question  Select Best Answer

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Also you can use group by on all columns you are pulling either by sql override or aggrigator

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

Use the sorter transformation and use "select distinct" property.Hanu.

Answer Question  Select Best Answer

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Query hints are used in RDBS concept, when you write SQLs in pervious days developer use give hint points while writing the query for DB engine, they are called rule based DB, now the rule based DB is fading out in the market, these days youwill find all new DBs as cost based

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Aggregate awareness is the method in Business Objects while creating measures in the universe, it is process where you define the aggregation strategy which you wanted BO to follow, useful mostly for Drill downs based on different dimentions

Answer Question  Select Best Answer

How can we display delimiters beside column names of target flat file?

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

While creating the targets using flat files we will get a options to specify whether the flat file is delimited of fixed length following tht steps in one of the steps we get how to notify the delimiters in the flat file there we can adjust delimiters beside the target columns name

Answer Question  Select Best Answer

sridhar39

 Profile Answers by sridhar39 Questions by sridhar39

• Dec 28th, 2007

hi,    both unconnected and connected will provide single output. if it is the case that we can use either unconnected or connected i prefer unconnected why because uncon...

Tarun Vig

• Oct 12th, 2007

Use of connected and unconnected Lookup ic completely based on the logic which we need.However i just wanted to clear that we can get multiple rows data from an Unconnected lookup also.Just concatinat...

Answer Question  Select Best Answer

sridhar39

 Profile Answers by sridhar39 Questions by sridhar39

• Dec 29th, 2007

hi,     when the informatica server starts a recovery session it reads the            opb_srvr_recovery table and notes the r...

chandrarekha

• Sep 28th, 2007

You have 3 steps in session recoveryIf Informatica server performs? no commit, run the session againAt least one commit, perform recoveryperform recovery is not possible, truncate the target table and run the session again.Rekha

Answer Question  Select Best Answer

sridhar39

 Profile Answers by sridhar39 Questions by sridhar39

• Dec 29th, 2007

hi      PMCMD means program command line utility.       it is a program command line utility to communicate with informatica server.  &...

chandrarekha

• Sep 28th, 2007

It a command line program. It performs the following tasksStart and stop the session and batchesStop the Informatica ServerChecks whether the server is working or not

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Jan 2nd, 2008

Write a post_session command in the session.For example : COPY C:PreviousFinaloutput.csv+C:newflatfilerecords.csv C:PreviousFinaloutput.csv

sm1506

• Apr 7th, 2006

this is not there in Informatica v 7. but heard that its included in the latest version 8.0 where u can append to a flat file. Its about to be shipping in the market.

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Jan 2nd, 2008

Write a post_session command in the session.For example : COPY C:PreviousFinaloutput.csv+C:newflatfilerecords.csv C:PreviousFinaloutput.csv

promila

• Jul 17th, 2007

HI , We can use /n as a delimiter to append data at the bottom and also checking the option - append in the workflow monitor . but i am not clear can we append data at the top . One way is to create&n...

Answer Question  Select Best Answer

We have one source and 3 targets with same fields i.e empno,ename in all 3 targets and source, then the 1st row in source should go to 1st target, 2nd row in source should go to 2nd target and the 3rd row in source should go to 3rd target, 4th row again to 1st target , 5th row to target2 6th row to target 3 like this we need to transfer data how is it possible?

sandeep.vaishy

 Profile Answers by sandeep.vaishy Questions by sandeep.vaishy

• Jan 14th, 2008

First Load Data from source To One dummy table in target with SEQ Gen T/R.in SEQ Gen T/R Set min value 1 and max value 3 and check the reset option.It will load the data with new column Values 1,2,3,1...

sekhar.ganta

 Profile Answers by sekhar.ganta Questions by sekhar.ganta

• Jan 3rd, 2008

here we should use router transformation with 3 groups. suppose 3 targets are target1: condition multiples of 3?????????? select * from emp where (empno,0) in (select empno,mod(rownum,3) fro...

Answer Question  Select Best Answer

What is IQD file?

Kalpana gopinath

 Profile Answers by Kalpana gopinath Questions by Kalpana gopinath

• Jan 14th, 2008

In Cognos u will have impromptu (reporting tool) in this all the report will be stored as report.IMR   which is  one dimensional (single view ) report .but when we want to build cubes&n...

Answer Question  Select Best Answer