siraj.khan

• Aug 3rd, 2007

No it's not possible. source qualifier don't have any variables fields to utilize as expression.

premlahari

 Profile Answers by premlahari Questions by premlahari

• Dec 13th, 2005

No. we can't do. I will explain you why. 1) Unless you assign the output of the source qualifier to another transformation or to target no way it will include the feild in the query.2) source qualifier don't have any variables feilds to utalize as expression.

Answer Question  Select Best Answer

Azhar

• Mar 30th, 2006

Can someone guide me on1) Data profiling.2) Exporting independent and dependent objects.Thanks in advance.-Azhar

Rama

• Nov 28th, 2005

Features in 7.1 are :1.union and custom transformation2.lookup on flat file3.grid servers working on different operating systems can coexist on same server4.we can use pmcmdrep5.we can export independ...

Answer Question  Select Best Answer

Powercenter server contains the sheduled runs at which time data should load from source to target Repository contains all the definitions of the mappings done in designer.

na123

 Profile Answers by na123 Questions by na123

• Aug 22nd, 2006

power center server-power center server does the extraction from the source and loaded it to the target.repository server-it takes care of the connection between the power center client and repository...

Guest

• Jul 18th, 2006

hi,Repository is nothing but a set of tables created in a DB.it stores all metadata of the infa objects.Repository server is one which communicates with the repository i.e DB. all the metadata is retr...

Answer Question  Select Best Answer

Client having database throught that data base u get all sources

kishore

• Jan 29th, 2006

creating of staging tables/area is the work of data modellor/dba.just like  " create table ......"  the tables will be created. they will have some name to identified as staging like  dwc_tmp_asset_eval.tmp-----> indicate temparary tables nothing but staging

Gokulnath_J

 Profile Answers by Gokulnath_J Questions by Gokulnath_J

• Nov 8th, 2005

A Staging area in a DW is used as a temporary space to hold all the records from the source system. So more or less it should be exact replica of the source systems except for the laod startegy where ...

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

When you create a version of a folder referenced by shortcuts, all shortcuts continue to reference their original object in the original version. They do not automatically update to the current folder...

sri

• Nov 29th, 2005

Hi manoj,I appreciate ur response ,But can u be a bit clearthankssri

Answer Question  Select Best Answer

Jose

• Jan 27th, 2014

By default the maximum concurrent session is 10 and during installation we are setting the number of concurrent session.

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,please be more specific on the first half of the question.u set the max no of concurrent sessions in the info server.by default its 10. u can set to any no.

Answer Question  Select Best Answer

reddeppa

• Jan 1st, 2006

there is one formula..no.of bloccks=0.9*( DTM buffer size/block size)*no.of partitions.here no.of blocks=(source+targets)*2

pat

• Dec 7th, 2005

The restriction is only on the database side. how many concurrent threads r u allowed to run on the db server?

Answer Question  Select Best Answer

krishnasri424

 Profile Answers by krishnasri424 Questions by krishnasri424

• Dec 7th, 2006

Use sequence generator and set the 'Increment by' property in that with 2.

Pavan.m

• Dec 7th, 2006

Use sequence generator to generate warehouse keys and set the 'Increment by ' property of sequence genrator to 2.

Answer Question  Select Best Answer

deepika

• Nov 7th, 2006

Hi sunil,I got a problem with this...Can you jsut tell me a procedure to generate sequence number in SQl  like...if i give n no of emplyees it should generate seq.and i want to use them in informatica...using stored procedure and load them into target..can u help me with this..thanks

sunil kumar

• Feb 15th, 2006

CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION.if still is there any problem please contact me.Thanks Good Luck!

Answer Question  Select Best Answer

sreedhar

• Sep 27th, 2006

 u r sending data into two different tbls ... of course by setting primary key in the target tables ..the thing is  the surrogate key generation requires seperate mapping which suits for scd concept..

Dharma

 Profile Answers by Dharma Questions by Dharma

• Sep 20th, 2006

Plz explain me briefly regarding ths.Thank U

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

Naren

• Mar 29th, 2006

Also known as Junk DimensionsMaking sense of the rogue fields in your fact table..Please read the article http://www.intelligententerprise.com/000320/webhouse.jhtml 

thiyagarajanc

 Profile Answers by thiyagarajanc Questions by thiyagarajanc

• Mar 15th, 2006

Plz explain me Clearly what is meant by Mystery Dimension?

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• May 12th, 2008

For 1st question, the above answer is correct.for 2nd, NO, you are even unable to connect to the repository if informatica server is not started.  As such, no question of viewing your workflow and running it.

madhu

• Mar 1st, 2006

the difference between cache and uncacheed lookup iswhen you configure the lookup transformation cache lookup it stores all the lookup table data in the cache when the first input record enter into th...

Answer Question  Select Best Answer

Arvind

• Apr 11th, 2006

How can you edit the parameter file? Once you setup a mapping variable how can you define them in a parameter file?

SSekar

 Profile Answers by SSekar Questions by SSekar

• Mar 17th, 2006

If we need to change certain attributes of a mapping after every time the session is run, it will be very difficult to edit the mapping and then change the attribute. So we use mapping parameters and ...

Answer Question  Select Best Answer

sidhu

• Jan 25th, 2007

No GUI mode for informatica in unix. In Unix you cannot design the mappings and workflow as you do in windows. Unix operating sys can only be used to run the jobs, schudule it...


Sidhu

jagadeesh

• Apr 3rd, 2006

No GUI mode in unix till now.....Only command prompt will help in unix environment for pmrep and pmcmdfrom Jagadeesh

Answer Question  Select Best Answer

pruthvi

• Aug 9th, 2007

Hierarchy in DWH is nothing but an ordered series of related dimensions grouped together to perform multidimensional analysis.

kalyan

• May 1st, 2006

Data sources ---> Data acquisition ---> Warehouse ---> Front end tools ---> Metadata management ---> Data warehouse operation management

Answer Question  Select Best Answer

Hanu Ch rao

• Mar 2nd, 2007

Hi,You can override any property like pre-session, post-session and SQL query in SQT and like any other trans in the mapping except SGT (sequence Generator Trans) You cannot overide the properties of SGT in session level.

sm1506

• Apr 7th, 2006

1) I want to Know which mapping properties can be overridden on a Session Task level.You can override any properties other than the source and targets. Make sure the source and targets exists in ur db...

Answer Question  Select Best Answer

When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a n character.

sheeladere

 Profile Answers by sheeladere Questions by sheeladere

• Jan 4th, 2010

In the Fixed width file, the columns will be allotted with some specific length( fixed width), suppose your file contains 5 columns and total length of the file record is 100, then while defining...

Motilal

• Jun 30th, 2006

Ya.. Can anybody please give any suggestions?I think the source file needed to be cleaned manually

Answer Question  Select Best Answer

Prasad Parulekar

• May 14th, 2007

Use session parameters to make sessions more flexible. For example, you have the same type of transactional data written to two different databases, and you use the database connections TransDB1 and...

sm1506

• Apr 12th, 2006

HiYou are supposed to define a parameter file. And then in the Parameter file, you can define two parameters, one for source and one for target.Give like this for example:$Src_file = c:\program f...

Answer Question  Select Best Answer

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• May 16th, 2010

Bitmap indexes are widely used in data warehousing environments. The environments typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions. For such appl...

Shanmugam

• Jul 6th, 2006

Bitmap indexing a indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-norm...

Answer Question  Select Best Answer