Interested to Buy Any Domain ? << Click Here >> for more details...
-
Teradata (490) - Business Objects (875)
- Cognos (1143)
- Informatica (2428)
- Crystal Enterprise Suite (30)
- Actuate (46)
- Ab Initio (442)
- Data Stage (917)
- SAS (1049)
- Micro Strategy (282)
- ETL (315)
- OBIEE (92)
- IBM Cognos TM1 (55)
- Amazon Redshift (62)
- Data Warehouse General (749)
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
CTS,
1664how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
CTS,
1688I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
CTS,
1641What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
CTS,
1 2390How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
1507can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
3870Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 3542Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
1676we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?
2 2927
How to create an external dataset with sas code?
List few etl bugs?
which r the connectors used in san?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are the advantages and disadvantages of reporting directly against the database?
list out all the transformations which use cache?
Explain what are the various file formats involved in reportnet?
At which levels you can set the vldb properties? Which level has the highest pecedence?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is the basic structure of a sas program?
What is the difference between absolute and relative div positioning?
What is Discover and Execute in XMLA?
What is rank metrics in microstrategy?
explain what is factor analysis? : Sas-administrator
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
