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) hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
IBM,
4 13191,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
3 80082,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
2 6379there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
1 4857My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
6 11839I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
6 9691There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
IBM,
2244There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
IBM,
5 11665-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
TCS,
1 5791
Write the advantages of partitioning a session?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
How were the reports scheduled and how to resolve unexecuted documents?
What is a joiner transformation?
What is the SAS data set?
What is the sas data set? : sas-grid-administration
How to get the first 100 rows from the flat file into the target?
What are the different types of parallelism used in abinitio?
how to insert/update a csv file by comparing it with another csv file?
How do you convert single row from source into three rows into target?
update strategy transformation in informatica
what is ds administrator used for?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
what is difference between drill & scope of analysis?
How far Redshift is better in performance as compare to other data warehouse technologies?