vinodh259

 Profile Answers by vinodh259 Questions by vinodh259

• May 11th, 2007

who said that we cant use joiner for homogenous sources. but the thing is performace becomes bad if we use joiner transformation after source qualifier.? it is for the fact that for any sources (homo&...

Phani

• Feb 16th, 2007

This is because performing join at database level is must faster than performing join at session level. So, if source tables r originating from the same database( say relational) prefer join in the source qualifier transformation than for opting joiner transformation.regards,Phani...

Answer Question  Select Best Answer

vinod madala

• May 11th, 2007

Pulling the data from same type of sources using a same database link is called Homogenous. The key word is same databse link (thats the system DSN we use).

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

ramgan_tryst

 Profile Answers by ramgan_tryst Questions by ramgan_tryst

• May 15th, 2007

Check-In and Check-Out refers to Versioning your Mapping. It is like maintaining the changes you have made. It is like using VSS or CVS. When you right-click you mapping, you have a option called Versioning if you have got that facility enabled.

Answer Question  Select Best Answer

J.David Sukeerthi Kumar

• May 17th, 2007

There is on option called 'COMMIT INTERVAL', (By default its value is 10000 records)That means for every 10000 records? loaded ,the informatica server will issue an COMMIT command.If we specify 'SOUR...

Answer Question  Select Best Answer

SRIRAM N

• May 17th, 2007

You can compare two mappings 1) with in one folder 2) two mappings in two differnt foldersMapping Designer --> Open folders--> MAPPING tab --> Compare then select two mappings to compare.Thats it !? Thanks it is working.

Answer Question  Select Best Answer

g.nagaprasad

 Profile Answers by g.nagaprasad Questions by g.nagaprasad

• May 22nd, 2007

In lookup transformation there is a default clause ORDER BY...  but in case of Source Qualifier we have to give manually.

Answer Question  Select Best Answer

Yes.Because reusable tranformation is not contained with any maplet or maping.

Prasad

• May 22nd, 2007

Hi, you can use the mapping parameters or variables in a reusable transformation. And when you use the xformation in a mapping, during execution of the session it validates if the mapping parameter that is used in the xformation is defined with this mapping or not. If not, the session fails.

mahesh4346

 Profile Answers by mahesh4346 Questions by mahesh4346

• Feb 2nd, 2007

But when one cant use Mapping parameters and variables of one mapping in another Mapping then how can that be used in reusable transformation when Reusable transformations themselves can be used among...

Answer Question  Select Best Answer

naga

• May 24th, 2007

In realtime star schema is the better one. Surrogate key is linked to the lowest level. For example?country, state, city, area in this surrogate key is with 'AREA'

shaik

• Jun 27th, 2006

In real time only star schema will implement because it will take less time and surrogate key will there in each and every dimension table in star schema and this surrogate key will assign as foreign key in fact table.

Answer Question  Select Best Answer

Abhishek Pathak

• May 25th, 2007

Main difference between using a object from shared folder is that it will be used as Shortcut to shared folder so in future if any changes happened to that object so by changing its definition in...

Answer Question  Select Best Answer

Which transformation you can use to get n+1 records in Target database from N records source

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Normalizer bcoz it increases the no of rows. I hope it will help u.Thanks,imran

Answer Question  Select Best Answer

ex-: Suppose a table EMP is in MAINFRAME then how can we access this table as SOURCE TABLE in informatica?

latha

• May 29th, 2007

Use the Normalizer transformation to take the Mainframe sources(COBOL)

vishnukirank

 Profile Answers by vishnukirank Questions by vishnukirank

• May 26th, 2007

Use Informatica Power Connect to connect to external systems like Mainframes and import the source tables.

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi,The new Version Informatica 8.1 has got some additional feature's like:1) Mapping Generation Option2) Push Down Optimisation3) Data Cleanse and Match4) Data Federation (EII)5) Enterprise Grid6)...

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi Manish Bhai, Cofiguration management means when u r installing the informatica that time u have some options to set according to ur choice. Like u want to use unicode and ascii mode, there r some other options. I have only this much idea about it. If i am right then tell me.ThanksImran Nabi

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 30th, 2007

Hi,You can do it through file list. You have create a file containing path of all file. And u have to give that file name in session properties and select indirect.Thanks,imran

Answer Question  Select Best Answer

Navin

• Jun 2nd, 2007

With 32-bit the max memory?you can have for a session is 2^32With 64-bit?the max memory you can have 2^64 - more memory means?faster execution of sessionNavin

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 5th, 2007

The default user groups:      1) Administrators      2) Public

Answer Question  Select Best Answer