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

Abhik

• Nov 1st, 2006

If the source is relational u can use DISTINCT option in SQ and if it flat file u can use sorter for this

gop

• Jun 14th, 2006

hi,how you seperate distinct value using filter, where you write no dictinct value. please make it more clear.

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

hi,if u r using a update strategy in any of ur mapping, then in session properties u have to set treat source rows as Data Driven. if u select insert or udate or delete, then the info server will not ...

windows

 Profile Answers by windows Questions by windows

• Jun 2nd, 2006

You can set the following update strategy options: Insert. Select this option to insert a row into a target table. Delete. Select this option to delete a row from a table. Update. You have three diffe...

Answer Question  Select Best Answer

gazulas

 Profile Answers by gazulas Questions by gazulas

• Apr 22nd, 2009

All depends on your code.In general transformation errors like, date conversions, in-compatible data for a port. etc may arise at transformation level.

max

• May 9th, 2006

May be you will encounter with connection faliure, other then that i don't think so, cuzserver will handle all the syntex errors and Invalid mappings.

Answer Question  Select Best Answer

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...

Appadu Dora P

• Apr 25th, 2006

Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc......

Answer Question  Select Best Answer

I am getting installation problems while trying to install Informatica 6.1It says that PmRepServer service should be installed.Any suggestions should be appreciated

Motilal

• Jun 30th, 2006

You need to check the repository server, informatica server and client while installing. Meta data and ODBC are optional.Then while installing, the user name needed to be given same as the O.S usernam...

reddy

• May 8th, 2006

when iam trying to install the s/w..it says PmRepserver needs to started...i had tried it many waysplzz help me in this regardany suggestions are apprecaited.

Answer Question  Select Best Answer

In a Flat File source there r Null as well as Blank values .If u r doing the profiling for that source ,how do u gete counts for the Null and Blank separately instead of getting them as one countThanksManish

Jaspreet_banga

 Profile Answers by Jaspreet_banga Questions by Jaspreet_banga

• Jun 8th, 2011

For This first of all replace the null values by some default values and blank values by other default values then use Count(*) operator in select clause along with IN statement EG:-SELECT COUNT(*) FROM table_name WHERE coulmn_name IN('default_1','default_2');

S.Velava

 Profile Answers by S.Velava Questions by S.Velava

• Apr 13th, 2010

Use aggregate transformation with count to specify the null and blank.Count with the condition of not equal to null to get the count of blank values and as well to get the count of null values chk with the Null.

Answer Question  Select Best Answer

MAni

• Nov 7th, 2006

Stop : After issuing stop PCS processes all those records which it got from source qualifier and writes to the target.Abort: It works in the same way as stop but there is a time out period of 60sec.

rkarthikeyan

• May 18th, 2006

Stop:We can Restart the sessionAbort:WE cant restart the session.We should truncate all the pipeline after that start the session

Answer Question  Select Best Answer

geetham

 Profile Answers by geetham Questions by geetham

• Jan 3rd, 2007

- To do lookup on flatfile, only static cache can be used.

priyamayee

 Profile Answers by priyamayee Questions by priyamayee

• Jun 8th, 2006

Hii, We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the ...

Answer Question  Select Best Answer

vinay

• Jul 24th, 2006

if we go by the direct meaning of your question....there is no need for a new mapping for a new databse, you just need to change the connections in the workflow manager to run the mapping on another database

prasad

• Jul 13th, 2006

u can also do it this way. connect to both the repositories, open the respective folders. keep the destination repository as active. from the navigator panel just drag and drop the mapping to the work area. it will ask whether to copy the mapping,say YES. its done.

Answer Question  Select Best Answer