GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 92 of 127    Print  
Problems with Datastage - Date format & Null Handling of a Date field in a schema file
Hi,

I have a .csv file as my source.I am reading the data using a
sequential file stage.

Then I am validating the format of the data using a schema file.

The date format of the incoming file is '%dd/%mm/%yyyy'.So the date
column has a fixed length 10.

Now according to the provided incoming data set the date column should
be nullable.

Can anybody please provide an idea how to handle a nullable date
column using a schema file in Datastage?


  
Total Answers and Comments: 0 Last Update: January 09, 2008     Asked by: moumitamitra 
  
 Sponsored Links

 

No answers are posted for this question yet.
Be the first to answer it!


 Related Questions

Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
Read Answers (6) | Asked by : Madhavi
Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
We have the Datastage server7.5 installed on Unix machine. We need to have a DSN to connect to the database which is on some other unix machine.please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX?It is very urgent for us and we are not able to solve?pls help me in this regard.Madhavi
Read Answers (1) | Asked by : Madhavi
Latest Answer : To handle the error handling you can use the reject link option available in the transformer stage. ...
Read Answers (1) | Asked by : Amar
Latest Answer : Parallel extender is that the parallel processing of data extraction and transformation application . there are two types of parallel processing 1) pipeline parallelism 2) partition parallelism. ...
Read Answers (2) | Asked by : Deepak Prasad
View Question | Asked by : saritha.ppr
If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error?
Read Answers (6) | Asked by : etl
Latest Answer : two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------> ...
Can a sequential file stage can read the path from other sequential file. in which the data is stored
Latest Answer : what type of error dud you got.explain error. ...
Read Answers (1) | Asked by : mallikharjuna reddy

 Sponsored Links

 
Related Articles

Performing DML Operations on XML Schema Based XMLType Views

Performing DML Operations on XML Schema Based XMLType Views Analyzing the underlying query of the empSch v view discussed in the preceding section you may note that each attribute of the EMP T object used in the select list maps to a certain column of a single table namely emps What this means in pr
 

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
 

ODP.NET - Handling Nulls when Working with OracleDataReader

ODP NET Handling Nulls when Working with OracleDataReader When we work with OracleDataReader or for that matter even with data rows in a data table we may come across nulls The following is the efficient way to deal in with such scenarios mosgoogle geshibot language VB NET" create connect
 

ODP.NET - Handling Nulls when Executing with ExecuteScalar

ODP NET Handling Nulls when Executing with ExecuteScalar The most important issue to remember is that ExecuteScalar simply returns an object type of data The object refers to any data type within NET If the data type of your variable matches with the type of object returned by ExecuteScalar an impli
 

C++ String Representation and Handling

C String Representation and Handling In this C tutorial you will learn about string representation and handling how is string represented end string notation initializing char array character representation string literals example programe to understand the character array concept and the accessing
 

JavaScript Date Object

JavaScript Date Object In this JavaScript tutorial you will learn about date object and methods of date object explained along with syntax and example mosgoogle center JavaScript Date Object Usage of Date Object Date object of Java Script is used to work with date and times General syntax for defini
 

What is Conceptual Schema

In any data warehouse implementation there are many different considerations which should in place before the final physical setting up. This is to avoid in problems related to quality of data and consistencies in data processes. A conceptual schema is an abstract definition of the whole project.
 

What is Data File

In a logical data model, the conceptual data model which is based on the business semantic is being defined. Thus, entities and relationships and corresponding table and column design, object oriented classes, and XML tags, among other things are being laid regardless of the database will be physica
 

What is Business Schema

A schema that represents the structure of business transactions used by clients in the real world. It is considered to be unnormalized data. The dictionary defines the word "schema" as a plan, diagram, scheme or an underlying organizational structure.  It can also mean a c
 

String handling functions

What is the string handling functions present in header file <string.h>? There are number of string handling functions present in string.h. In other words if a programmer uses any of the function present in string.h then they must include the header file as #include <string.h&am
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape