Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

while creating the scd mappings. we will mention flag value.
what exactly the use of defining the FLAG VALUE. Please
explaine indetaile

Question Posted / ravikumar2614

Answers were Sorted based on User's Feedback



while creating the scd mappings. we will mention flag value. what exactly the use of defining the ..

Answer / rohan

in SCD2, the flag value indicates whether the record is the active record(Current version of the record) or not.

Is This Answer Correct ?    4 Yes 0 No

while creating the scd mappings. we will mention flag value. what exactly the use of defining the ..

Answer / kishor baindoor

In SCD each record is flaged in mapping logic so that
record will either inserted or upated or deleted
accordingly. You can flag record as 'I' or 'U' or 'D'

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

Why union transformation is an active transformation?

0 Answers   Informatica,

How to load duplicate records in to a target table which has a primary key?

2 Answers  

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,

comonly how meny mappings r there in Banking projects?

1 Answers  

What is joiner transformation?

0 Answers  

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

Write the unconnected lookup syntax?

0 Answers  

can session assigned multiple mappings or not?

2 Answers   Zensar,

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

For more Informatica Interview Questions Click Here
Categories