Sree.nivas

 Profile Answers by Sree.nivas Questions by Sree.nivas

• Oct 1st, 2007

If we  use same sequence generator for multiple times to load the data at same time there will be DEAD LLOCK occurs.To avoid  Dead locks we dont use same sequence generator

Rich

• Nov 17th, 2006

You can use sequence generator,but is the usein the mapping,it create not unique value

Answer Question  Select Best Answer

chandrarekha

• Sep 28th, 2007

Fact table without measure is called factless fact tablefact less fact tables are used to capture date transaction events

ramakrishna

• Sep 18th, 2007

A Fact table with out measures is called fact less fact table

Answer Question  Select Best Answer

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 26th, 2007

if u use order by clause in the lookup it improves the performance. because system generated order by consists all the lookup ports in the orderby clause. instood use ur own order by clause. so that the input data can be sorted by the way u likeex. order by deptno--

chandrarekha

• Sep 24th, 2007

No ,It decreses the performance

Answer Question  Select Best Answer

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 26th, 2007

we do. we have to update or insert a row in the target depending upon the data from the sources. so inorder to split the rows either to update or insert into the target table we use the lookup transformation in reference to target table and compared with source table.

Answer Question  Select Best Answer

I want to start a workflow from one server to another server. It means,upto now In UNIX Server i have all the scripts and in the same server only we are storing the Infomatica Repositories, hence to start that workflow iam using "pmcmd" command. Now i am getting a situation where this Repositories will reside in another server. Now Basis on that i want Built a script. Can any one Help me. Get back...

sriluck

 Profile Answers by sriluck Questions by sriluck

• Sep 25th, 2007

I came acrross a similar situation in my project.The scenario was:my script consisted of calling the informatica sessions and calling ora_sql functions to run sql scripts.Informatica was  recidin...

Answer Question  Select Best Answer

sriluck

 Profile Answers by sriluck Questions by sriluck

• Sep 25th, 2007

Hi Bharati,for the answer to your question, take 2 targetswith same instances T1 and T2.Lets say in T1 new records are populated.the records in T2 are checked for updation and populated accordingly.Then we can set the target load plan for updation to happen before insertion.

Answer Question  Select Best Answer

The aggregator stores data in the aggregate cache until it completes aggregate calculations.When u run a session that uses an aggregator transformation,the informatica server creates index and data caches in memory to process the transformation.If the informatica server requires more space,it stores overflow values in cache files.

chandrarekha

• Sep 24th, 2007

when? server runs the session with aggregate transformation ,it stores data in memory until it completes the aggregation when u partition a source ,the server creates one memory cache and one disk ca...

bneha15

 Profile Answers by bneha15 Questions by bneha15

• Apr 18th, 2007

Aggregate cache contains data values while aggregate calculations are being performed. Aggregate cache is made up of index cache and data cache. Index cache contains group values and data cache consists of row values.

Answer Question  Select Best Answer

chandrarekha

• Sep 24th, 2007

First column of the bad file indicates row -indicator and second column indicates column indicatorRow indicator :  Row indicator tells the writer what to do with the row of wrong dataRow indicato...

Answer Question  Select Best Answer

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 24th, 2007

The lookup table is used to split the data by comparing the source and target data. the data is branched accordingly whether to update or insert  

Answer Question  Select Best Answer

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 24th, 2007

we can do this by using mapping wizard.  there are of basically two types:1)getting started wizzard2)scdgettign started wizard is used when there is  no need to change the previous data.scd can hold the historical data.

Answer Question  Select Best Answer

ramakrishna

• Sep 22nd, 2007

A measurable data on which simple addition can be performed is called fully additive such measurable data's no need to combine two or more dimensions for it's meaningEx: Product wise total salesBr...

murali

• Nov 27th, 2006

Average monthly balance of your bank account is a semi-additive fact.

Answer Question  Select Best Answer

Abhishek

• Sep 21st, 2007

We can add header and footer record in two ways.1) Within the informatica session we can sequence the data as such that the header flows in first and footer flows in last. This only holds true wh...

Answer Question  Select Best Answer

venu adavelly

• Sep 17th, 2007

|| is used to concatinate two or more columns in Informaticafor exp; firstname (venu)last name (adavelly)but expecting out put is venu adavellyso we need to concatinate firstname and last name fristna...

Answer Question  Select Best Answer

venu adavelly

• Sep 17th, 2007

We can get multiple values from unconnected lookup return port using conncatination logic, then we have to split the values to respect columns?Do you need more information call 9833705604venu adavelly?

kavit gupta

• Aug 23rd, 2007

It s not possible to return more than one value using unconnected lookup. You can not opt more than one return (R) port in unconnected lookup.

Answer Question  Select Best Answer

This transformation is used to maintain the history data or just most recent changes in to target table.

chandrarekha

• Sep 12th, 2007

Update strategy transformation is used for flagging the records for insert, update, delete and reject In Informatica power center u can develop update strategy at two levels use update strategy T/...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

The model you choose constitutes your update strategy, how to handle changes to existing rows. In PowerCenter and PowerMart, you set your update strategy at two different levels: Within a session. Whe...

Answer Question  Select Best Answer

Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session. Unlike a mapping parameter,a maping variable represents a value that can change...

chandrarekha

• Sep 12th, 2007

Mapping parameter represents a constant value defined before mapping run.
Mapping reusability can be achieved by using mapping parameters.

Mapping variable represents a value that can be changed during the mapping run.
Mapping variable can be used in incremental loading process.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

You can use mapping parameters and variables in the SQL query, user-defined join, and source filter of a Source Qualifier transformation. You can also use the system variable $$$SessStartTime. The Inf...

Answer Question  Select Best Answer

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Sep 12th, 2007

Datawarehousing projects are different from the traditional OLTP project. First of all they are ongoing. A datawarehouse project is never "complete". Here most of the time the business users...

Answer Question  Select Best Answer

Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my dba used same in a mapping which have 5 rel SRCS from a single db and contain expression -- directed to TGT)

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Sep 7th, 2007

Adding to Mr. Sriram Kumar, As per the investigation I did with SAMPLE keyword in SQ trans......and fortunately its working.............Thx

Sriram Kumar N

• Aug 10th, 2007

You can use LEFT OUTER JOIN or RIGHT OUTER JOINS in source qualifier trans as SQL override. But make sure that you are not combining two or more outer joins using the same table as the inner table of more than one outer join.More information reach me @ sriram . kumar @ oneindia . in

Answer Question  Select Best Answer

Sujaya

• Sep 3rd, 2007

There is no default group in Filter Transformation. The records which does not satisfy filter condition are discarded and not written to reject file or session log file

babu

• Jul 11th, 2007

The rows which are not satisfing the filter transformation are discarded. It does not appear in the session logfile or reject files.

Answer Question  Select Best Answer

THEJASWINI

• Sep 1st, 2007

$ - These are the system variables like $Bad file,$input file, $output file, $DB connection$$ - user defined variables$$$ - $$$SessStartTime $$$SessStartTime returns the initial system date value on t...

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Aug 27th, 2007

Generally, As I know. $ refers Session Parameters like $source,$target. $$ refers Mapping Parameters like $$State,$$Time. $$$ refers System Parameters like $$$SessStartTime. I am requesting any other in pool Please check & let me know if I was wrong.

Answer Question  Select Best Answer